LEFT JOIN in MS ACCESS - VBForums

To register for an Internet.com membership to receive newsletters and white papers, use the Register button ABOVE.
To participate in the message forums BELOW, click here

VB Wire News

MSDN Subscribers: Download the VS 2010 Release Candidate
MSDN Subscribers: Download the VS 2010 Release Candidate
Sell Your Code and Make Money?
Creating your own Tetris game using VB.NET
Article :: Improving Software Economics, Part 4 of 7: Top 10 Principles of Iterative Software Management

		VBForums > Visual Basic > Visual Basic 6 and Earlier
LEFT JOIN in MS ACCESS

Mark Forums Read

Reply

Post New Thread

Search this Thread

May 5th, 2006, 07:50 PM	#1
mutley Fanatic Member Join Date: Apr 00 Location: Sao Paulo - Brazil Posts: 527	LEFT JOIN in MS ACCESS Hi What is wrong in select below ? Code: SELECT TB02_PK, TB02_NOME,TB02_NICK,TB05S_DESCR FROM TB02 LEFT JOIN TB05S ON TB02.TB02_FUNCAOID = TB05S.TB05S_PK ORDER BY 2 When I execute in VB return me Two rows , but in MS ACCESS return 3 Rows, In the Access Work fine What is Wrong ?

Reply

« Previous Thread | Next Thread »

		VBForums > Visual Basic > Visual Basic 6 and Earlier
LEFT JOIN in MS ACCESS

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Forum Rules

Forum Jump

All times are GMT -5. The time now is 01:20 PM.