0

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?

3
Contributors
4
Replies
5
Views
8 Years
Discussion Span
Last Post by vb5prgrmr
0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.