DaniWeb IT Discussion Community - can two ms sql table display information on one vb datagrid???

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)

- Visual Basic 4 / 5 / 6 (http://www.daniweb.com/forums/forum4.html)

- - can two ms sql table display information on one vb datagrid??? (http://www.daniweb.com/forums/thread200865.html)

gingank

Jul 1st, 2009 5:49 am

can two ms sql table display information on one vb datagrid???

Hi guy it is possible two table information with same information expect the badge ID display it on one vb datagrid???

vb5prgrmr

Jul 1st, 2009 9:01 am

Re: can two ms sql table display information on one vb datagrid???

Look up INNER JOIN in either SQL's Help files or Access's help files

Good Luck

sengreen

Jul 5th, 2009 1:46 pm

Re: can two ms sql table display information on one vb datagrid???

select Emp.id,Emp.name,Profession.skills from Emp inner join Profession on Emp.id=Profession.id

All times are GMT -4. The time now is 11:58 pm.