Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help me troubleshoot the error..."<filedname>" could not be boun 1

Status
Not open for further replies.
rahulroy08

rahulroy08

Programmer
Jul 3, 2007
58
US
Hi

I'm new to SQL Server and I'm trying to run the following query

Code: 
SELECT
    NSS_REPORT.dbo.ALLOCATE."DATE_ALLOC", NSS_REPORT.dbo.ALLOCATE."SEASON_ID",
    NSS_REPORT.dbo.DATECOLL."START_DATE"
FROM
    NSS_REPORT.dbo.allocate  oj left outer join NSS_REPORT.dbo.datecoll on 
    NSS_REPORT.dbo.allocate.date_alloc = NSS_REPORT.dbo.datecoll.start_date and
    NSS_REPORT.dbo.datecoll.datetype = 'H'
WHERE
    NSS_REPORT.dbo.allocate.date_alloc >= {D '1998-01-01'} and 
    NSS_REPORT.dbo.allocate.date_alloc < {D '1998-02-01'}

and I get the following error..

Code: 
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "NSS_REPORT.dbo.allocate.date_alloc" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "NSS_REPORT.dbo.allocate.date_alloc" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "NSS_REPORT.dbo.allocate.date_alloc" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "NSS_REPORT.dbo.ALLOCATE.DATE_ALLOC" could not be bound.

Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "NSS_REPORT.dbo.ALLOCATE.SEASON_ID" could not be bound


Please help me.


Thanks


Rahul.
 
Sort by date Sort by votes
This...

Code: 
NSS_REPORT.dbo.allocate  [!]oj [/!]

The oj in the previous part represents a table alias. When using a table alias, you need to use it everywhere in the query. Like this...

Code: 
[COLOR=blue]SELECT[/color]
    [COLOR=blue]oj[/color]."DATE_ALLOC", [COLOR=blue]oj[/color]."SEASON_ID",
    NSS_REPORT.dbo.DATECOLL."START_DATE"
[COLOR=blue]FROM[/color]
    NSS_REPORT.dbo.allocate  [COLOR=blue]oj[/color] [COLOR=#FF00FF]left[/color] [COLOR=blue]outer[/color] [COLOR=blue]join[/color] NSS_REPORT.dbo.datecoll [COLOR=blue]on[/color]
    [COLOR=blue]oj[/color].date_alloc = NSS_REPORT.dbo.datecoll.start_date and
    NSS_REPORT.dbo.datecoll.datetype = [COLOR=red]'H'[/color]
[COLOR=blue]WHERE[/color]
    [COLOR=blue]oj[/color].date_alloc >= [COLOR=blue]D[/color] [COLOR=red]'1998-01-01'[/color] and
    [COLOR=blue]oj[/color].date_alloc < [COLOR=blue]D[/color] [COLOR=red]'1998-02-01'[/color]

-George

"the screen with the little boxes in the window." - Moron
 
Upvote 0 Downvote
thanks it was successful.

Now I also have another code
Code: 
SELECT
    ALLOCATE."DATE_ALLOC", ALLOCATE."MINACCRATE",
    ROOMNITE."BUS_ID", ROOMNITE."ROOMDATE", ROOMNITE."ROOMDEF_ID", ROOMNITE."SYSROOM_ID", ROOMNITE."SING_RATE", ROOMNITE."DOUB_RATE", ROOMNITE."TRIP_RATE", ROOMNITE."QUAD_RATE", ROOMNITE."SINGLE_QTY", ROOMNITE."DOUBLE_QTY", ROOMNITE."TRIPLE_QTY", ROOMNITE."QUAD_QTY",
    PERFBUCKET."BNUM_1", PERFBUCKET."BNUM_2",
    BUSINESS."BUS_ID", BUSINESS."BUS_GID", BUSINESS."BUSSTSYNAB", BUSINESS."ABBREV", BUSINESS."AVG_RATE", BUSINESS."CREATE_DAT", BUSINESS."LOST_SYSID", BUSINESS."PICKUP_YN",
    BUSSTSYN."BUSSTSYNTX",
    PERSON."PER_INIT",
    MRKETSEG."MARKET_ABV"
FROM
    ALLOCATE --(*vendor(Microsoft),product(ODBC) oj LEFT OUTER JOIN UBUCKET ON ALLOCATE.DATE_ALLOC=UBUCKET.BDATE_1 AND UBUCKET.UKEY_USER=0 AND UBUCKET.BNUM_1=1 LEFT OUTER JOIN DATECOLL ON ALLOCATE.DATE_ALLOC = DATECOLL.START_DATE LEFT OUTER JOIN ROOMNITE ON ALLOCATE.DATE_ALLOC = ROOMNITE.ROOMDATE LEFT OUTER JOIN BUSINESS ON ROOMNITE.BUS_ID = BUSINESS.BUS_ID AND ROOMNITE.BUS_GID = BUSINESS.BUS_GID LEFT OUTER JOIN BUSSTSYN BUSSTSYN ON BUSINESS.BUSSTSYNID = BUSSTSYN.BUSSTSYNID AND BUSINESS.BUSSTSYGID = BUSSTSYN.BUSSTSYGID LEFT OUTER JOIN BUSTYSYN BUSTYSYN ON BUSINESS.TY_SYN_ID = BUSTYSYN.TY_SYN_ID AND BUSINESS.TYSYN_GID = BUSTYSYN.TYSYN_GID LEFT OUTER JOIN  PERSON ON BUSINESS.BOOKEDBY = PERSON.PERSON_ID AND BUSINESS.BOOKEDBYG = PERSON.PERSON_GID LEFT OUTER JOIN ORGANIZ ON BUSINESS.CLIENT = ORGANIZ.ORG_ID AND BUSINESS.CLIENTG = ORGANIZ.ORG_GID LEFT OUTER JOIN MRKETSEG ON ORGANIZ.MKT_SEG_ID = MRKETSEG.MKT_SEG_ID AND ORGANIZ.MKTSEG_GID = MRKETSEG.MKTSEG_GID*)-- 
WHERE
    allocate.date_alloc >= {D '1998-01-01'} and allocate.date_alloc < {D '1998-02-01'} and BUSTYSYN.SYSBUSTYID <> 1

which is also of the same issue... I tried the way u suggested but was confused and it was a big mess... can you please help me correct this as well..

it gives me the following error
Code: 
Msg 102, Level 15, State 1, Line 10
Incorrect syntax near '--(*'.


once again your help is appreciated.


Rahul.
 
Upvote 0 Downvote
If you need to comment a part of line use:
Code: 
/* comment goes here */
not --

[--] Comments all till the end of the line.


Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP
 
Upvote 0 Downvote
I find a lot of times that if you make better use of white-space, that it is easier to debug a procedure.

Try this...

Code: 
[COLOR=blue]SELECT[/color]
    [COLOR=blue]ALLOCATE[/color]."DATE_ALLOC", 
    [COLOR=blue]ALLOCATE[/color]."MINACCRATE",
    ROOMNITE."BUS_ID", 
    ROOMNITE."ROOMDATE", 
    ROOMNITE."ROOMDEF_ID", 
    ROOMNITE."SYSROOM_ID", 
    ROOMNITE."SING_RATE", 
    ROOMNITE."DOUB_RATE", 
    ROOMNITE."TRIP_RATE", 
    ROOMNITE."QUAD_RATE", 
    ROOMNITE."SINGLE_QTY", 
    ROOMNITE."DOUBLE_QTY", 
    ROOMNITE."TRIPLE_QTY", 
    ROOMNITE."QUAD_QTY",
    PERFBUCKET."BNUM_1", 
    PERFBUCKET."BNUM_2",
    BUSINESS."BUS_ID", 
    BUSINESS."BUS_GID", 
    BUSINESS."BUSSTSYNAB", 
    BUSINESS."ABBREV", 
    BUSINESS."AVG_RATE", 
    BUSINESS."CREATE_DAT", 
    BUSINESS."LOST_SYSID", 
    BUSINESS."PICKUP_YN",
    BUSSTSYN."BUSSTSYNTX",
    PERSON."PER_INIT",
    MRKETSEG."MARKET_ABV"
[COLOR=blue]FROM[/color]
    [COLOR=blue]ALLOCATE[/color] 
    [COLOR=#FF00FF]LEFT[/color] [COLOR=blue]OUTER[/color] [COLOR=blue]JOIN[/color] UBUCKET 
      [COLOR=blue]ON[/color]  [COLOR=blue]ALLOCATE[/color].DATE_ALLOC=UBUCKET.BDATE_1 
      AND UBUCKET.UKEY_USER=0 
      AND UBUCKET.BNUM_1=1 
    [COLOR=#FF00FF]LEFT[/color] [COLOR=blue]OUTER[/color] [COLOR=blue]JOIN[/color] DATECOLL 
      [COLOR=blue]ON[/color] [COLOR=blue]ALLOCATE[/color].DATE_ALLOC = DATECOLL.START_DATE 
    [COLOR=#FF00FF]LEFT[/color] [COLOR=blue]OUTER[/color] [COLOR=blue]JOIN[/color] ROOMNITE 
      [COLOR=blue]ON[/color] [COLOR=blue]ALLOCATE[/color].DATE_ALLOC = ROOMNITE.ROOMDATE 
    [COLOR=#FF00FF]LEFT[/color] [COLOR=blue]OUTER[/color] [COLOR=blue]JOIN[/color] BUSINESS 
      [COLOR=blue]ON[/color]  ROOMNITE.BUS_ID = BUSINESS.BUS_ID 
      AND ROOMNITE.BUS_GID = BUSINESS.BUS_GID 
    [COLOR=#FF00FF]LEFT[/color] [COLOR=blue]OUTER[/color] [COLOR=blue]JOIN[/color] BUSSTSYN BUSSTSYN 
      [COLOR=blue]ON[/color]  BUSINESS.BUSSTSYNID = BUSSTSYN.BUSSTSYNID 
      AND BUSINESS.BUSSTSYGID = BUSSTSYN.BUSSTSYGID 
    [COLOR=#FF00FF]LEFT[/color] [COLOR=blue]OUTER[/color] [COLOR=blue]JOIN[/color] BUSTYSYN BUSTYSYN 
      [COLOR=blue]ON[/color]  BUSINESS.TY_SYN_ID = BUSTYSYN.TY_SYN_ID 
      AND BUSINESS.TYSYN_GID = BUSTYSYN.TYSYN_GID 
    [COLOR=#FF00FF]LEFT[/color] [COLOR=blue]OUTER[/color] [COLOR=blue]JOIN[/color]  PERSON 
      [COLOR=blue]ON[/color]  BUSINESS.BOOKEDBY = PERSON.PERSON_ID 
      AND BUSINESS.BOOKEDBYG = PERSON.PERSON_GID 
    [COLOR=#FF00FF]LEFT[/color] [COLOR=blue]OUTER[/color] [COLOR=blue]JOIN[/color] ORGANIZ 
      [COLOR=blue]ON[/color]  BUSINESS.CLIENT = ORGANIZ.ORG_ID 
      AND BUSINESS.CLIENTG = ORGANIZ.ORG_GID 
    [COLOR=#FF00FF]LEFT[/color] [COLOR=blue]OUTER[/color] [COLOR=blue]JOIN[/color] MRKETSEG 
		[COLOR=blue]ON[/color] 	ORGANIZ.MKT_SEG_ID = MRKETSEG.MKT_SEG_ID 
		AND ORGANIZ.MKTSEG_GID = MRKETSEG.MKTSEG_GID
[COLOR=blue]WHERE[/color]
    [COLOR=blue]allocate[/color].date_alloc >= [COLOR=red]'1998-01-01'[/color] and [COLOR=blue]allocate[/color].date_alloc < [COLOR=red]'1998-02-01'[/color] and BUSTYSYN.SYSBUSTYID <> 1

-George

"the screen with the little boxes in the window." - Moron
 
Upvote 0 Downvote
Hi Borislav,

If I use /* for the comments then it gives me the following error

Code: 
FROM
    ALLOCATE /*vendor(Microsoft),product(ODBC) */ oj (LEFT OUTER JOIN UBUCKET ON ALLOCATE.DATE_ALLOC=UBUCKET.BDATE_1 AND UBUCKET.UKEY_USER=0 AND UBUCKET.BNUM_1=1 LEFT OUTER JOIN DATECOLL ON ALLOCATE.DATE_ALLOC = DATECOLL.START_DATE LEFT OUTER JOIN ROOMNITE ON ALLOCATE.DATE_ALLOC = ROOMNITE.ROOMDATE LEFT OUTER JOIN BUSINESS ON ROOMNITE.BUS_ID = BUSINESS.BUS_ID AND ROOMNITE.BUS_GID = BUSINESS.BUS_GID LEFT OUTER JOIN BUSSTSYN BUSSTSYN ON BUSINESS.BUSSTSYNID = BUSSTSYN.BUSSTSYNID AND BUSINESS.BUSSTSYGID = BUSSTSYN.BUSSTSYGID LEFT OUTER JOIN BUSTYSYN BUSTYSYN ON BUSINESS.TY_SYN_ID = BUSTYSYN.TY_SYN_ID AND BUSINESS.TYSYN_GID = BUSTYSYN.TYSYN_GID LEFT OUTER JOIN  PERSON ON BUSINESS.BOOKEDBY = PERSON.PERSON_ID AND BUSINESS.BOOKEDBYG = PERSON.PERSON_GID LEFT OUTER JOIN ORGANIZ ON BUSINESS.CLIENT = ORGANIZ.ORG_ID AND BUSINESS.CLIENTG = ORGANIZ.ORG_GID LEFT OUTER JOIN MRKETSEG ON ORGANIZ.MKT_SEG_ID = MRKETSEG.MKT_SEG_ID AND ORGANIZ.MKTSEG_GID = MRKETSEG.MKTSEG_GID) 
WHERE
    allocate.date_alloc >= {D '1998-01-01'} and allocate.date_alloc < {D '1998-02-01'} and BUSTYSYN.SYSBUSTYID <> 1


and gives me the error as..

Code: 
 Msg 156, Level 15, State 1, Line 10
Incorrect syntax near the keyword 'LEFT'.


Please Help
 
Upvote 0 Downvote
George,
your method looks pleasant to debug, but when I tried that way, still it gives me an error,

Code: 
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "PERFBUCKET.BNUM_1" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "PERFBUCKET.BNUM_2" could not be bound.

What do I do now ?


Please help.
 
Upvote 0 Downvote
Welcome back George!
:)

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP
 
Upvote 0 Downvote
You again aliased table and didn' use that alias anywhere. Remember When you alias table you MUST use that alias in your query, nit the table name
Code: 
SELECT MyTable.Field
       FROM MyTable MTbl
will generate an error, but:
Code: 
SELECT MTbl1.Field
       FROM MyTable MTbl
will not.
So PUT oj in comments:
[/code]
--change
/*vendor(Microsoft),product(ODBC) */ oj
-- to
/*vendor(Microsoft),product(ODBC) oj */
[/code]


Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP
 
Upvote 0 Downvote
Borislav

I did the same.I put the oj in the comments as well
It still gives me an error

Code: 
Msg 156, Level 15, State 1, Line 10
Incorrect syntax near the keyword 'OUTER'.

I dont understand what is the problem.

 
Upvote 0 Downvote
How about this:
Code: 
SELECT
    ALLOCATE."DATE_ALLOC", ALLOCATE."MINACCRATE",
    ROOMNITE."BUS_ID", ROOMNITE."ROOMDATE", ROOMNITE."ROOMDEF_ID", ROOMNITE."SYSROOM_ID", ROOMNITE."SING_RATE", ROOMNITE."DOUB_RATE", ROOMNITE."TRIP_RATE", ROOMNITE."QUAD_RATE", ROOMNITE."SINGLE_QTY", ROOMNITE."DOUBLE_QTY", ROOMNITE."TRIPLE_QTY", ROOMNITE."QUAD_QTY",
    PERFBUCKET."BNUM_1", PERFBUCKET."BNUM_2",
    BUSINESS."BUS_ID", BUSINESS."BUS_GID", BUSINESS."BUSSTSYNAB", BUSINESS."ABBREV", BUSINESS."AVG_RATE", BUSINESS."CREATE_DAT", BUSINESS."LOST_SYSID", BUSINESS."PICKUP_YN",
    BUSSTSYN."BUSSTSYNTX",
    PERSON."PER_INIT",
    MRKETSEG."MARKET_ABV"
FROM
    ALLOCATE  LEFT OUTER JOIN UBUCKET ON ALLOCATE.DATE_ALLOC=UBUCKET.BDATE_1 AND UBUCKET.UKEY_USER=0 AND UBUCKET.BNUM_1=1 LEFT OUTER JOIN DATECOLL ON ALLOCATE.DATE_ALLOC = DATECOLL.START_DATE LEFT OUTER JOIN ROOMNITE ON ALLOCATE.DATE_ALLOC = ROOMNITE.ROOMDATE LEFT OUTER JOIN BUSINESS ON ROOMNITE.BUS_ID = BUSINESS.BUS_ID AND ROOMNITE.BUS_GID = BUSINESS.BUS_GID LEFT OUTER JOIN BUSSTSYN BUSSTSYN ON BUSINESS.BUSSTSYNID = BUSSTSYN.BUSSTSYNID AND BUSINESS.BUSSTSYGID = BUSSTSYN.BUSSTSYGID LEFT OUTER JOIN BUSTYSYN BUSTYSYN ON BUSINESS.TY_SYN_ID = BUSTYSYN.TY_SYN_ID AND BUSINESS.TYSYN_GID = BUSTYSYN.TYSYN_GID LEFT OUTER JOIN  PERSON ON BUSINESS.BOOKEDBY = PERSON.PERSON_ID AND BUSINESS.BOOKEDBYG = PERSON.PERSON_GID LEFT OUTER JOIN ORGANIZ ON BUSINESS.CLIENT = ORGANIZ.ORG_ID AND BUSINESS.CLIENTG = ORGANIZ.ORG_GID LEFT OUTER JOIN MRKETSEG ON ORGANIZ.MKT_SEG_ID = MRKETSEG.MKT_SEG_ID AND ORGANIZ.MKTSEG_GID = MRKETSEG.MKTSEG_GID
WHERE
    allocate.date_alloc >= {D '1998-01-01'} and allocate.date_alloc < {D '1998-02-01'} and BUSTYSYN.SYSBUSTYID <> 1

And please format the query so it will be easier to read.


Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP
 
Upvote 0 Downvote
that code which you specified compiles successfully but does not execute it gives me an error


how about this code (though even this compiles successfully...it does not get executed)...It gives me execution errors

Code: 
SELECT
    "NSS_REPORT"."dbo".ALLOCATE."DATE_ALLOC", 
    "NSS_REPORT"."dbo".ALLOCATE."MINACCRATE",
    "NSS_REPORT"."dbo".ROOMNITE."BUS_ID",
    "NSS_REPORT"."dbo".ROOMNITE."ROOMDATE",
    "NSS_REPORT"."dbo".ROOMNITE."ROOMDEF_ID",
    "NSS_REPORT"."dbo".ROOMNITE."SYSROOM_ID",
    "NSS_REPORT"."dbo".ROOMNITE."SING_RATE",
	"NSS_REPORT"."dbo".ROOMNITE."DOUB_RATE",
	"NSS_REPORT"."dbo".ROOMNITE."TRIP_RATE",
	"NSS_REPORT"."dbo".ROOMNITE."QUAD_RATE",
	"NSS_REPORT"."dbo".ROOMNITE."SINGLE_QTY",
	"NSS_REPORT"."dbo".ROOMNITE."DOUBLE_QTY",
	"NSS_REPORT"."dbo".ROOMNITE."TRIPLE_QTY",
	"NSS_REPORT"."dbo".ROOMNITE."QUAD_QTY",
    "NSS_REPORT"."dbo".PERFBUCKET."BNUM_1",
	"NSS_REPORT"."dbo".PERFBUCKET."BNUM_2",
    "NSS_REPORT"."dbo".BUSINESS."BUS_ID",
	"NSS_REPORT"."dbo".BUSINESS."BUS_GID",
	"NSS_REPORT"."dbo".BUSINESS."BUSSTSYNAB",
	"NSS_REPORT"."dbo".BUSINESS."ABBREV",
	"NSS_REPORT"."dbo".BUSINESS."AVG_RATE",
	"NSS_REPORT"."dbo".BUSINESS."CREATE_DAT",
	"NSS_REPORT"."dbo".BUSINESS."LOST_SYSID",
	"NSS_REPORT"."dbo".BUSINESS."PICKUP_YN",
    "NSS_REPORT"."dbo".BUSSTSYN."BUSSTSYNTX",
    "NSS_REPORT"."dbo".PERSON."PER_INIT",
    "NSS_REPORT"."dbo".MRKETSEG."MARKET_ABV"
FROM
  "NSS_REPORT"."dbo".ALLOCATE oj 
    LEFT OUTER JOIN "NSS_REPORT"."dbo".UBUCKET 
		ON "NSS_REPORT"."dbo".ALLOCATE.DATE_ALLOC="NSS_REPORT"."dbo".UBUCKET.BDATE_1
		AND "NSS_REPORT"."dbo".UBUCKET.UKEY_USER=0 
		AND "NSS_REPORT"."dbo".UBUCKET.BNUM_1=1 

    LEFT OUTER JOIN "NSS_REPORT"."dbo".DATECOLL 
        ON "NSS_REPORT"."dbo".ALLOCATE.DATE_ALLOC = "NSS_REPORT"."dbo".DATECOLL.START_DATE

    LEFT OUTER JOIN "NSS_REPORT"."dbo".ROOMNITE 
		ON "NSS_REPORT"."dbo".ALLOCATE.DATE_ALLOC = "NSS_REPORT"."dbo".ROOMNITE.ROOMDATE
 
	LEFT OUTER JOIN "NSS_REPORT"."dbo".BUSINESS 
		ON "NSS_REPORT"."dbo".ROOMNITE.BUS_ID = "NSS_REPORT"."dbo".BUSINESS.BUS_ID 
		AND "NSS_REPORT"."dbo".ROOMNITE.BUS_GID = "NSS_REPORT"."dbo".BUSINESS.BUS_GID

	LEFT OUTER JOIN "NSS_REPORT"."dbo".BUSSTSYN 
		ON "NSS_REPORT"."dbo".BUSINESS.BUSSTSYNID = "NSS_REPORT"."dbo".BUSSTSYN.BUSSTSYNID 
		AND "NSS_REPORT"."dbo".BUSINESS.BUSSTSYGID = "NSS_REPORT"."dbo".BUSSTSYN.BUSSTSYGID

	LEFT OUTER JOIN "NSS_REPORT"."dbo".BUSTYSYN 
		ON "NSS_REPORT"."dbo".BUSINESS.TY_SYN_ID = "NSS_REPORT"."dbo".BUSTYSYN.TY_SYN_ID
		AND "NSS_REPORT"."dbo".BUSINESS.TYSYN_GID = "NSS_REPORT"."dbo".BUSTYSYN.TYSYN_GID
   
	LEFT OUTER JOIN "NSS_REPORT"."dbo".PERSON 
		ON "NSS_REPORT"."dbo".BUSINESS.BOOKEDBY = "NSS_REPORT"."dbo".PERSON.PERSON_ID 
		AND "NSS_REPORT"."dbo".BUSINESS.BOOKEDBYG = "NSS_REPORT"."dbo".PERSON.PERSON_GID
   
	LEFT OUTER JOIN "NSS_REPORT"."dbo".ORGANIZ 
		ON "NSS_REPORT"."dbo".BUSINESS.CLIENT = "NSS_REPORT"."dbo".ORGANIZ.ORG_ID 
		AND "NSS_REPORT"."dbo".BUSINESS.CLIENTG = "NSS_REPORT"."dbo".ORGANIZ.ORG_GID
 
    LEFT OUTER JOIN "NSS_REPORT"."dbo".MRKETSEG 
		ON "NSS_REPORT"."dbo".ORGANIZ.MKT_SEG_ID = "NSS_REPORT"."dbo".MRKETSEG.MKT_SEG_ID 
		AND "NSS_REPORT"."dbo".ORGANIZ.MKTSEG_GID = "NSS_REPORT"."dbo".MRKETSEG.MKTSEG_GID
WHERE
    "NSS_REPORT"."dbo".allocate.date_alloc >= {D '1998-01-01'} 
	and "NSS_REPORT"."dbo".allocate.date_alloc < {D '1998-02-01'} 
	and BUSTYSYN.SYSBUSTYID <> 1

Code: 
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "NSS_REPORT.dbo.ALLOCATE.DATE_ALLOC" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "NSS_REPORT.dbo.ALLOCATE.DATE_ALLOC" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "NSS_REPORT.dbo.ALLOCATE.DATE_ALLOC" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "NSS_REPORT.dbo.allocate.date_alloc" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "NSS_REPORT.dbo.allocate.date_alloc" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "NSS_REPORT.dbo.ALLOCATE.DATE_ALLOC" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "NSS_REPORT.dbo.ALLOCATE.MINACCRATE" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "NSS_REPORT.dbo.PERFBUCKET.BNUM_1" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "NSS_REPORT.dbo.PERFBUCKET.BNUM_2" could not be bound.


And if I try the other way the one you just sent me...even then it gives me errors...

Code: 
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "PERFBUCKET.BNUM_1" could not be bound.

Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "PERFBUCKET.BNUM_2" could not be bound.


Please Help


Rahul.
 
Upvote 0 Downvote
Did you read what I post about ALIAS the table?
It that code you ALIAS "NSS_REPORT"."dbo".ALLOCATE to oj BUT you don't use taht ALIAS nowhere in the query. You still use ALLOCATE. Also when you use full qualifier you must use IT (like you do).
So why not simplify your life and use something like:
Code: 
[COLOR=blue]SELECT[/color]
    [COLOR=blue]ALLOCATE[/color]."DATE_ALLOC",
    [COLOR=blue]ALLOCATE[/color]."MINACCRATE",
    ROOMNITE."BUS_ID",
    ROOMNITE."ROOMDATE",
    ROOMNITE."ROOMDEF_ID",
    ROOMNITE."SYSROOM_ID",
    ROOMNITE."SING_RATE",
    ROOMNITE."DOUB_RATE",
    ROOMNITE."TRIP_RATE",
    ROOMNITE."QUAD_RATE",
    ROOMNITE."SINGLE_QTY",
    ROOMNITE."DOUBLE_QTY",
    ROOMNITE."TRIPLE_QTY",
    ROOMNITE."QUAD_QTY",
    PERFBUCKET."BNUM_1",
    PERFBUCKET."BNUM_2",
    BUSINESS."BUS_ID",
    BUSINESS."BUS_GID",
    BUSINESS."BUSSTSYNAB",
    BUSINESS."ABBREV",
    BUSINESS."AVG_RATE",
    BUSINESS."CREATE_DAT",
    BUSINESS."LOST_SYSID",
    BUSINESS."PICKUP_YN",
    BUSSTSYN."BUSSTSYNTX",
    PERSON."PER_INIT",
    MRKETSEG."MARKET_ABV"
[COLOR=blue]FROM[/color] "NSS_REPORT"."dbo".ALLOCATE [COLOR=blue]ALLOCATE[/color]
    [COLOR=#FF00FF]LEFT[/color] [COLOR=blue]OUTER[/color] [COLOR=blue]JOIN[/color] "NSS_REPORT"."dbo".UBUCKET UBUCKET
        [COLOR=blue]ON[/color] [COLOR=blue]ALLOCATE[/color].DATE_ALLOC = UBUCKET.BDATE_1
       AND UBUCKET.UKEY_USER=0
       AND UBUCKET.BNUM_1=1

    [COLOR=#FF00FF]LEFT[/color] [COLOR=blue]OUTER[/color] [COLOR=blue]JOIN[/color] "NSS_REPORT"."dbo".DATECOLL DATECOLL
        [COLOR=blue]ON[/color] [COLOR=blue]ALLOCATE[/color].DATE_ALLOC = DATECOLL.START_DATE

    [COLOR=#FF00FF]LEFT[/color] [COLOR=blue]OUTER[/color] [COLOR=blue]JOIN[/color] "NSS_REPORT"."dbo".ROOMNITE ROOMNITE
        [COLOR=blue]ON[/color] [COLOR=blue]ALLOCATE[/color].DATE_ALLOC = ROOMNITE.ROOMDATE
 
    [COLOR=#FF00FF]LEFT[/color] [COLOR=blue]OUTER[/color] [COLOR=blue]JOIN[/color] "NSS_REPORT"."dbo".BUSINESS BUSINESS
        [COLOR=blue]ON[/color] ROOMNITE.BUS_ID = "BUSINESS.BUS_ID
        AND ROOMNITE.BUS_GID = BUSINESS.BUS_GID

    [COLOR=#FF00FF]LEFT[/color] [COLOR=blue]OUTER[/color] [COLOR=blue]JOIN[/color] "NSS_REPORT"."dbo".BUSSTSYN BUSSTSYN
        [COLOR=blue]ON[/color] BUSINESS.BUSSTSYNID = BUSSTSYN.BUSSTSYNID
        AND BUSINESS.BUSSTSYGID = BUSSTSYN.BUSSTSYGID


Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP
 
Upvote 0 Downvote
Tried it but no luck.

Not sure what to do.

herez another one..

Code: 
SELECT
    oj."RM_MONTH",oj."BEG_DATE", oj."BEG_STAT", oj."BEG_BLK", oj."BEG_PKP", oj."END_DATE", oj."END_STAT", oj."END_BLK", oj."END_PKP",oj."END_PKRB", oj."END_NPRB", oj."END_PKRP", oj."END_NPRP", oj."END_PKREVB", oj."END_NPREVB", oj."END_PKREVP", oj."END_NPREVP",
    PERFBUCKET."BNUM_2", PERFBUCKET."BNUM_3", PERFBUCKET."BNUM_4", PERFBUCKET."BNUM_5", PERFBUCKET."BNUM_6", PERFBUCKET."BNUM_7", PERFBUCKET."BNUM_8", PERFBUCKET."BNUM_9", PERFBUCKET."BNUM_10", PERFBUCKET."BNUM_11", PERFBUCKET."BNUM_12",
    BUSINESS."PICKUP_DATE"
FROM
    MONTHPRF  oj 
    Left Outer Join PERFBUCKET on
    oj.RM_MONTH = PERFBUCKET.BNUM_1 and
    PERFBUCKET.UKEY_USER = 0 and
    PERFBUCKET.UKEY_ID = 1000 and
    PERFBUCKET.UKEY_GID = 1000
WHERE
    rm_month >= 199801 and oj.ukey_user = 7


Please help thanks..
 
Upvote 0 Downvote
The last column you are selecting is from a table called Business. ( [!]BUSINESS."PICKUP_DATE"[/!] )

This table does not exist in the from clause.

-George

"the screen with the little boxes in the window." - Moron
 
Upvote 0 Downvote
Thanks George,

I will try looking into it, and will get back to you, for further help.


I appreciate your help.


Rahul.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
Is &quot;IF EXISTS()...&quot; better than &quot;IF (SELECT COUNT...) &gt; 0&quot;
Replies
4
Views
2K
gmmastros
gmmastros
Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
462
Chris Miller
Chris Miller
f0rg3tfu1
  • Locked
  • Question
PLSQL Package Help
Replies
0
Views
541
f0rg3tfu1
f0rg3tfu1
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
1K
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
fill the gap of hierarchy data
Replies
11
Views
953
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top