[TECK]

can you please explain to me what are the LEFT JOIN functions when doing a query?
i see it all the time when grabbing some code from a table.

thanks alot.

[Chen]

Shouldn't you, eh... get married instead of mumbling about JOINs?

[Mark Hensler]

(inner) joins combine two tables where a field in table1 match a field in table2. any records that do not have a match, are thrown out of the resulting recordset

left joins include all matches and any orphan records from the left table

right joins appear to do the same but really reverse the table order, then perfom a left join

outer joins include all records


all records that do not have a matching record from the other table will have null values for those fields

[TECK]

thanks alot mark.
firefly, ur not gonna believe it.. the plane broke down.. i post in details what happened in Lounge..
i will be leaving tomorrow at 4pm.. grrrrrr