mysql - Creating DataTable with inner join query on DataSet -


i'm having small issue on trying create datatable following query:

select sp_sales_data.productname, sp_sales_data.quantity, sp_sales_data.tax_percent, sp_sales_data.finalprice, sp_sales.date, sp_stores.location, sp_sales.change, sp_sales.ammountreceived, sp_sales.totaltopay, sp_users.firstname, sp_users.lastname, sp_company_data.logo, sp_company_data.maincity, sp_company_data.name, sp_company_data.mainzipcode, sp_company_data.nif, sp_company_data.phone sp_sales_data  inner join sp_sales on sp_sales_data.sale_id = sp_sales.id inner join sp_users on sp_sales.client = sp_users.id inner join sp_stores on sp_sales.store = sp_stores.id inner join sp_company_data on sp_company_data.id = '1' 

it reports me following problem: error in select clause : expression near date missing clause. unable parse query text

the preview works fine tableadapter still empty


Comments

Popular posts from this blog

c++ - Difference between pre and post decrement in recursive function argument -

php - Nothing but 'run(); ' when browsing to my local project, how do I fix this? -

php - How can I echo out this array? -