CREATE TABLE tbl_T0(fid int, haz float); CREATE TABLE tbl_T1(fid int, foo text); CREATE TABLE tbl_T2(fid int, bar money); Populate each table with some data, then create views with ROW_NUMBER(): ...
My actual work query was an inner join, but this simple example with cross join seems to nearly always reproduce the problem. SELECT * FROM ( SELECT 1 UNION ALL SELECT 2 ) AA ( A ) CROSS JOIN ...
I have three relevent tables: Parts, PartGroup, and MarkupGroup. Parts is simple. PartID artificial primary key Part part number PartGroupID Foreign key sample data: 1 ...