| | |
..joining 2 tables?=A tuf one....can U crack this ?
Please support our VB.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!
![]() |
•
•
Join Date: Aug 2006
Posts: 5
Reputation:
Solved Threads: 0
Listen, I 've 2 tables of the following nature :
Table 1
---------
col1 | col2 | col3 |
--------------------------------------------------------
1 name1 xxxxxxxxxx
1 name1 ssssssssssss
1 name1 rrrrrrrrrrrrrr
2 name1 qqqqqqqqqq
2 name1 eeeeeeeeee
and so on........
Table 2
=======
col1 | col2 | col3
------------------------------------------------------
1 name1 1111111111
2 name1 2222222222
Now , I would like to join these 2 tables.....
What kind of a record selection formula do I write ???
Any help.......is welcome.....
Bye.
Table 1
---------
col1 | col2 | col3 |
--------------------------------------------------------
1 name1 xxxxxxxxxx
1 name1 ssssssssssss
1 name1 rrrrrrrrrrrrrr
2 name1 qqqqqqqqqq
2 name1 eeeeeeeeee
and so on........
Table 2
=======
col1 | col2 | col3
------------------------------------------------------
1 name1 1111111111
2 name1 2222222222
Now , I would like to join these 2 tables.....
What kind of a record selection formula do I write ???
Any help.......is welcome.....
Bye.
SELECT * FROM Table1 INNER JOIN Table2 on TABLE1.col1 = TABLE2.col2
* will selct all fields, if you want certain fields, do TABLE1.col1, TABLE2.col2
Does this Help??
* will selct all fields, if you want certain fields, do TABLE1.col1, TABLE2.col2
Does this Help??
Gabriel Villa
software development/ IT support consultant
software development/ IT support consultant
![]() |
Similar Threads
- Repeated Row In Record Sets (MS SQL)
- Joining 4 or more tables (MySQL)
- dataabse connectin string problem? (MySQL)
- Need Help Joining 3 tables (MySQL)
- PHP newbie, project feasibility (PHP)
- updating 2 HTML tables on one PHP page (PHP)
Other Threads in the VB.NET Forum
- Previous Thread: How do I store Unique Values to More than One Same Names in Database using VB.NET
- Next Thread: Infinite closing loop... HELP!
| Thread Tools | Search this Thread |
"crystal .net .net2005 30minutes 2008 access add application arithmetic array assignment basic box button buttons click code combo component connectionstring convert cpu data database databasesearch datagrid datagridview design designer dissertation dissertations dissertationthesis dosconsolevb.net editvb.net exists file-dialog firewall folder forms hardcopy image images isnumericfuntioncall listview math mobile module mssqlbackend mysql navigate networking number opacity output peertopeervideostreaming picturebox1 picturebox2 port print printpreview problemwithinstallation project record regex reports" reuse right-to-left savedialog serial socket sqldatbase sqlserver storedprocedure string temp text textbox timer toolbox txttoxmlconverter updown useraccounts usercontol usercontrol vb vb.net vb.netcode vb.nettoolboxvisualbasic2008sidebar vbnet view vista visual visualbasic visualbasic.net visualstudio visualstudio.net web wpf wrapingcode xml





