August 15th, 2004, 01:22 AM
|
|
Registered User
|
|
Join Date: Jun 2004
Posts: 25
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
reply to a dumb person for a change
whats the difference b/w "inner join" and "outer join"?
is anything wrong with the following code?
code:
PHP Code:
ALTER PROCEDURE selectjobsearch
(
@emuser varchar(20)=null,
@emcity varchar (50)=null,
@emprovince char(2)=null,
@emcountry char (2)=null,
@joposted smalldatetime=null,
@jotitle varchar(100)=null,
@jodetails varchar(4000),
@category varchar(50)=null,
@industry varchar(50)=null
)
AS
SELECT Jobs.jid, Employer.emname, Jobs.jotitle, Jobs.jocutoff, Industries.industry
FROM (Industries INNER JOIN (Employer INNER JOIN Jobs ON Employer.emuser = Jobs.emuser) ON Industries.indid = Jobs.indid) INNER JOIN (Categories INNER JOIN JobCat ON
Categories.catid = JobCat.catid) ON Jobs.jid = JobCat.jid
Where Employer.emuser=@emuser
or Employer.emcity=@emcity
or Employer.emprovince=@emprovince
or Employer.emcountry=@emcountry
or Jobs.joposted=@joposted
or Jobs.jotitle like '%' + @jotitle + '%'
or Jobs.jodetails like '%' + @jodetails + '%'
or Categories.category=@category
or Industries.industry=@industry
i m trying to search for some job detials.
when i run the SQL command i dont get any records in return
what did i do wrong?
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
