Left join of subquery not working in SQL Server -


i'm having lot of trouble adding subquery in left join, when run combined query separate parts each piece works, when try run whole thing fails , i've tried fix syntax , change lettering , adding parentheses nothing seems help, query below:

 select *    (select sales_doc_type,           doc_date,           sales_doc_num,           sales_person_id,           customer_name,           shipping_method,           total,           subtotal,           xintfreight,           xsalesmancost,           source,           xcommisionpaid,           payment_terms    [vispr].[dbo].[spv3salesdocument]    sales_doc_type = 'invoice'      , sales_person_id = 'xx01'    union select sales_doc_type,                     doc_date,                     sales_doc_num,                     sales_person_id,                     customer_name,                     shipping_method,                     total,                     subtotal,                     xintfreight,                     xsalesmancost,                     source,                     xcommisionpaid,                     payment_terms    [vispr].[dbo].[spv3salesdocumenthistory]    sales_doc_type = 'invoice'      , sales_person_id = 'xx01'      , source not in ('void')) inner join [vispr].[dbo].[sop30200] b on a.sales_doc_num = b.sopnumbe , a.sales_doc_type = b.docid left join [vispr].[dbo].[spvsalesdocumenttrackingnumber] c on a.sales_doc_num = c.sales_doc_num , a.sales_doc_type = c.sales_doc_type d left join   (select distinct x.sales_doc_num,                    x.po_number,                    y.xpocomm    [vispr].[dbo].[spvsaleslinepo] x,         vispr.dbo.spxpurchaseorder y    x.po_number = y.po_number) e on d.sales_doc_num = e.sales_doc_num 

when select before "as d" , execute results, when select subquery forming "e" runs when try execute entire thing error:

msg 156, level 15, state 1, line 13
incorrect syntax near keyword 'as'.
msg 156, level 15, state 1, line 16
incorrect syntax near keyword 'as'.

any appreciated, i've been able figure these types of issues out before syntax or structure related, here can't after hours of trying , searching answers. there limit on table/query aliases, though don't seem have many?

update query one.

select * (select sales_doc_type,       doc_date,       sales_doc_num,       sales_person_id,       customer_name,       shipping_method,       total,       subtotal,       xintfreight,       xsalesmancost,       source,       xcommisionpaid,       payment_terms [vispr].[dbo].[spv3salesdocument] sales_doc_type = 'invoice'  , sales_person_id = 'xx01' union select sales_doc_type,                 doc_date,                 sales_doc_num,                 sales_person_id,                 customer_name,                 shipping_method,                 total,                 subtotal,                 xintfreight,                 xsalesmancost,                 source,                 xcommisionpaid,                 payment_terms [vispr].[dbo].[spv3salesdocumenthistory] sales_doc_type = 'invoice'  , sales_person_id = 'xx01'  , source not in ('void')) inner join [vispr].[dbo].[sop30200] b on a.sales_doc_num = b.sopnumbe , a.sales_doc_type = b.docid left join [vispr].[dbo].[spvsalesdocumenttrackingnumber] c on a.sales_doc_num = c.sales_doc_num  , a.sales_doc_type = c.sales_doc_type left join (select distinct x.sales_doc_num,                x.po_number,                y.xpocomm  [vispr].[dbo].[spvsaleslinepo] x,     vispr.dbo.spxpurchaseorder y x.po_number = y.po_number) e on c.sales_doc_num = e.sales_doc_num 

Comments

Popular posts from this blog

java - Intellij Synchronizing output directories .. -

git - Initial Commit: "fatal: could not create leading directories of ..." -