Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- void query_three(Connection conn)
- {
- try
- {
- PreparedStatement ps = conn.prepareStatement(
- "create view Q6c as " +
- "SELECT Q6a.tutorialRef " +
- "FROM Q6a, Q6b " +
- "WHERE Q6a.tutorialRef = Q6b.tutorialRef " +
- "AND Q6b.PM_BOOKED > Q6a.AM_BOOKED"
- );
- ps.executeQuery();
- ps.close();
- } catch (Exception e) {
- e.printStackTrace();
- }
- }
Add Comment
Please, Sign In to add comment