I've 3 tables A,B,C <br />records in table A like: <br /><u>id name</u><br />b1 abc <br />b2
xyz<br />b3 rst <p>records in table B like: <br /><u>id type</u><br />b1 logistics <br />b1
importer<br />b2 logistics <br />b3 logistics <br />b3 exporter <p>records in table C like: <br
/><u>id offer title</u><br />b1 sell car <br />b1 buy car <br />b1
sell van <br />b2 sell car <p>How shoul I do a query so that I can get a result like <br />(The
querywill be based on B.type ='logistics') <br /><u>id name offer</u><br />b1 abc sell <br
/>b1 abc buy <br />b1 abc sell <br />b2 xyz sell <br />b3
rst -- <p>Any help very much appricated