Problem vb programming about the sql inner join

[gingank]

Hi guys i need help on this can help me can help me to correct it. I want the inner join table 1 & table 2 not show a row in the data grid in the vb6

my sql statement is like this:
sql = " Select * from staff_badgeTracking " _
& " inner join staff_badgeTrackingNew " _
& " On staff_badgeTracking.Badge_ID = staff_badgeTrackingNew.Badge_ID"

the output something like this

Badge ID Emp_ID Emp_Name Badge_ID Emp ID Emp_Name
1234 5566 Nana 1234 7788 Nana

If i dun to show like that can show then show like this way in the data grid:
Badge ID Emp_ID Emp_Name
1234 5566 Nana
1234 7788 Nana

[vb5prgrmr]

Create temp table with insert into from one table, use insert into from other table, then select records from temp table. When done, delete temp table if you want or keep it around and reuse it in future.

Good Luck

[gingank]

Create temp table with insert into from one table, use insert into from other table, then select records from temp table. When done, delete temp table if you want or keep it around and reuse it in future.

Good Luck

1. How to create temp table?
2. sql statement insert into can give example?
3. Can you simple your word i cant understand?

[vb5prgrmr]

Use INSERT INTO statement (search site, your threads), so...

Create Table by using insert into from first table
Then use insert into from second table
Then select * from temp table
Then your option
delete records to reuse table later
or
delete table (drop statement)

Good Luck

[gingank]

Use INSERT INTO statement (search site, your threads), so...

Create Table by using insert into from first table
Then use insert into from second table
Then select * from temp table
Then your option
delete records to reuse table later
or
delete table (drop statement)

Good Luck

Still not understand. Cause i so stupid can you write out the source code for me. So that i can refer from it? Please Help me thank you