sqlselect aidxqlxwllxysjzsjbjkssjazbdh as xydhaznsbt as xybtabjjzsjaformmodeidbformidamodedatacreatedateamodedatacreatetime from uf_src_bid a left join modeinfo b on afor

This SQL statement selects data from two tables, uf_src_bid and uf_src_rfq, and joins them using the union all operator. The selected columns include id, xqlx, wllx, ysjzsj, bjkssj, xydh, xybt, bjjzsj, formmodeid, formid, modedatacreatedate, and modedatacreatetime.

The first select statement selects data from uf_src_bid and joins it with modeinfo table on the condition that formmodeid in uf_src_bid matches id in modeinfo. The where clause filters the data based on the current time being less than bjjzsj, xyfs being equal to 1, lc being equal to 1, and zt being in (1, 2, 7, 9).

The second select statement selects data from uf_src_rfq and joins it with modeinfo table on the condition that formmodeid in uf_src_rfq matches id in modeinfo. The where clause filters the data based on the same conditions as the first select statement.

The union all operator combines the results of both select statements and returns a single result set