>Thanks .. Just what I was looking for.
>regards,
>Gerard
>
>
>>>>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
>>>

SELECT * FROM TableA CROSS JOIN TableB

>>
>>This syntax is not supported by all SQL versions, and in particular not by VFP against DBFs.

I guess you can't expect cutting edge syntax support (after all it's only been ANSI standard for the last 19 odd years) :-}