User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
DaniWeb is a massive community of 423,155 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,429 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Showing results 1 to 6 of 6
Search took 0.02 seconds.
Posts Made By: Tara423
Forum: MS SQL Mar 13th, 2008
Replies: 10
Views: 819
Posted By Tara423
Re: sql - how to

So, now I know a good way to test the 'yuck' Access sql syntax!

Thank you for the help.

Cheers,
Tara
Forum: MS SQL Mar 12th, 2008
Replies: 10
Views: 819
Posted By Tara423
Re: sql - how to

Oh my God! It worked! I can't tell you how very very happy I am. :icon_smile:

Actually, I just assumed that that the sql MS Access uses is going to be same as MS sql :$

Thanks a billion for your...
Forum: MS SQL Mar 12th, 2008
Replies: 10
Views: 819
Posted By Tara423
Re: sql - how to

Mission unsuccessful!

For some reason, whatever way I try it doesn't seem to be working.

I am connecting to MS Access database through VC++. In whatever way I try to add an extra 'inner join' it...
Forum: MS SQL Mar 12th, 2008
Replies: 10
Views: 819
Posted By Tara423
Re: sql - how to

OOPS. please ignore the above post. I did not see your 2nd post.

Thanks,
Tara
Forum: MS SQL Mar 12th, 2008
Replies: 10
Views: 819
Posted By Tara423
Re: sql - how to

Thank you for the reply.

I tried the sql as you have given. It gives the phone and fax details of the vendors but it also lists down all the items. It is not selecting only those items that have the...
Forum: MS SQL Mar 12th, 2008
Replies: 10
Views: 819
Posted By Tara423
sql - how to

Hi,

I have two table like this:



I am trying to write an sql that given me the following result:
Showing results 1 to 6 of 6

 
All times are GMT -4. The time now is 7:32 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC