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

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

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?

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

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

This article has been dead for over six months. Start a new discussion instead.