How not to get selected data

You would need to specify the fields something like below.

Code:

SELECT tbl_a.column1 , tbl_a.column2
      tbl_b.column1 , tbl_b.column2
FROM   tbl_a , tbl_b
WHERE  tbl_a.commonfield=tbl_b.commonfield

What did you Try? What did you Get? What did you Expect?

Joined CodeIgniter Community 2009.  ( Skype: insitfx )