Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. sponsors. rss.
 From: Ulhas Amrite
  Where is Ulhas Amrite?
 Pune
 India
 Ulhas Amrite
 Tags
Subject: sql query what's wrong?
Thread ID: 122650 Message ID: 122650 # Views: 32 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Wednesday, February 21, 2007 8:03:29 AM         
   


What's wrong in the following sql query?

SELECT spomast.matcode, partmast.DESCRIPT, spomast.spono, procmast.DESCRIPTIO, ;
	spomast.sporate, spomast.maincode FROM spomast inner JOIN accmst ON spomast.maincode = accmst.maincode ;
	inner JOIN procmast oN spomast.proccode = procmast.proccode ;
	inner JOIN partmast ON spomast.matcode = partmast.partno where spomast.maincode = '136S05'


with this query no records are selected - where as if "where" clause is removed all records are selected.

Ulhas Amrite



COMPLETE THREAD
sql query what's wrong? Posted by Ulhas Amrite @ 2/21/2007 8:03:29 AM
RE: sql query what's wrong? Posted by tushar @ 2/21/2007 8:10:09 AM
RE: sql query what's wrong? Posted by Marc van der bij @ 2/21/2007 12:30:55 PM
RE: sql query what's wrong? Posted by Ken Murphy @ 2/21/2007 1:33:53 PM
RE: sql query what's wrong? Posted by Arjun Bagojikop @ 2/22/2007 3:50:25 AM