joins

[nikko50]

Hello there. I'm trying to join 2 tables together. I want all from table receive and then join table poscans. The unique fields in both tables is the ponum field. Here is what I have so far.

SELECT * FROM receive ORDER BY date
left join poscans on receive.ponum = poscans.ponum

[nikko50]

Here's is what I have now. I still need to get poscans.image column to attach to receive.

SELECT receive . *
FROM receive
LEFT JOIN poscans ON receive.ponum = poscans.ponum

[leatherback]

Hi,

The query looks ok to me. What is the question/problem?

SELECT *
FROM receive
LEFT JOIN poscans ON receive.ponum = poscans.ponum

J.