djc11
07-22-2008, 06:06 PM
I know this is probably really basic and i thought i used to be able to do this but what i want to do is basically join two tables. But if table2 doesn't have a matching record I still want the row with the data from table1 and empty values for the data from table2. Is this possible?