I have a table sel_freight keyed on selno. I have another table called selections which has a column ruid. I want a MySQL query that I can look up all selections for ruid 1234 where there is an entry (selno) in the sel_freight table. The column selno is common in both tables. Can you show me a MySQL query that does this?
Thank you