Sql join two table ?

[gingank]

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?

[abu taher]

see this thread, you can get profit to see it.http://www.daniweb.com/forums/thread158029.html

[gingank]

see this thread, you can get profit to see it.http://www.daniweb.com/forums/thread158029.html

But i not understand can you explain in detail to me

[abu taher]

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

[vb5prgrmr]

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