General information
Category:
Coding, syntax & commands
Title:
Join ALL fields from a second table
Is there a Sql select command I can use which ALWAYS joins ALL fields from a second Table onto a main Table
e.g. I have TABLE A with 100 records (Say Fields TA_1, TA_2, TA_3, TA_4, TA_5)
I have Table B with just one record and say 2 fields (TB_1, TB_2)
I want to end up with All 100 records from Table A, and in each of these Records I want ALL fields from Table B
So I end up with 100 records with fields (TA_1,TA_2,TA_3,TA_4,TA_5, TB_1, TB_2) where TB_1 and TB_2 will always have same value,
which will ahve come from Table B
Tia
Gerard
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only