Hi guys i'm using the join statement and then display it into the data grid. the problem is table 1 and table 1 info display it together like this

Badge_ID Emp _Name Active Badge_ID Emp _Name Active
1234 Nana Yes 1234 Hana No

How can i show like this in the data grid?
Badge_ID Emp _Name Active
1234 Nana Yes
1234 Hana No

How to do this can example in detail?

sorry. its not match with your thread. I understood wrong.

First create the new table from one of the other tables...

SELECT Table1.Field1, Table1.Field2, Table1.Field3 INTO tmpTbl FROM Table1

Then insert the records from the second table

INSERT INTO tmpTbl (Field1, Field2, Field3) SELECT Table2.Field1, Table2.Field2, Table2.Field3 FROM Table2

Now, select the records from the table

SELECT * FROM tmpTable

When done with table

DROP TABLE tmpTbl


Good Luck