Re: Vignesh, please don't hijack threads

[Jam Su]

Hi Peter,

I am also using Ver 8.0.21

I am not creating the tables, they already exist, however, here are the data types of the columns, hopefully that provides you with the information you are looking for?

p.num = varchar(70)
p.description = varchar(252)
po.num = varchar(25)
po.dateCreated = datetime(6)
poi.qtyToFulfill = decimal(28,9)

Please let me know if there is any other data you require.

Thank you,

Full Error posted below -

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(PARTITION BY p.num) 'NUM' FROM part p LEFT JOIN poitem poi ON poi.partid = p' at line 7