i am using the newer 7.3.2 version of postgresql and we jst switched up to it from 7.2.1 and i have a program that access the database and uses Left Outer Join to connect 2 tables. it worked like a charm in 7.2.1 but now that we have 7.3.2 it wont work. we still have the old server up and running but as soon as i get this fix we are dumping it. ok this is what happens i it will connect to both tables and get everything i need out of the first table and it goes into the second table and tryes to read it but it cant find anything. its like it thinks the table is empty or something.

these are the sql statements im using:


visual basic code:

Const sqlstatement = "Select * From inven as i Left Outer Join conn_xr as c on i.partnum = c.facpn"


visual basic code:

dbinven.RecordSource = _
"Select * From inven as i Left Outer Join conn_xr as c on i.partnum = c.facpn WHERE i.partnum = '" & strGetRec & "'"
dbfap.RecordSource = _
"Select * From inven as i Left Outer Join conn_xr as c on i.partnum = c.facpn WHERE i.partnum = '" & strGetRec & "'"
dbinven.Refresh
dbfap.Refresh


does anyone know what or if they did anything to postgresql that would make this not work.

well if you need anymore info about what im trying to do jst ask. and thanks for taking the time to read and help me out.