Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- \BEGIN{TABLE}
- \caption {main1where2}
- \BEGIN{tabular}{|l|}
- \hline
- Main query BEFORE \\ \hline
- SELECT * FROM ( ... )\\UNION SELECT ...\\LEFT OUTER JOIN Submissions \\LEFT OUTER JOIN Tasks \\\\LEFT OUTER JOIN Persons \\ ON Persons.PersonId = Submissions.PersonId \\ WHERE a1.PersonId = 1 \\ \hline
- Main query after \\ \hline
- UNION SELECT ... FROM (\\SELECT * FROM Approvers\\ WHERE PersonID = 1\\ ) AS a1 \\ \hline
- \END{tabular}
- \END{TABLE}
Advertisement
Add Comment
Please, Sign In to add comment