How to duplicate a record

• lanky_doodle

  SSCrazy

  Points: 2381

  More actions

  February 10, 2018 at 11:28 am

  #336093

  Hey,

  If I have a set of records, keep it simple with ID, User and Department:

  ID---------User------------Department
  1----------Joe Bloggs---Accounts
  2----------Jill Bloggs----Engineering

  On my web app I group by department, and show each person underneath. I'd like to have a favourites department per user, which is a simple intermediary table:

  ID-------Person---------User (this is the current logged in user)
  1---------Joe Bloggs---Jill Bloggs

  Now the result above for Jill Bloggs should now be.

  ID---------User------------Department
  1----------Joe Bloggs---Accounts
  2----------Jill Bloggs----Engineering
  3---------Joe Bloggs----Favourites

  The query for this resultset is quite complex so I'd like to avoid a union (and so repetition) if possible, but that is the result I want. Can I do a join to the intermediary table and have it show as an additional row with the fabricated department as 'Favourite'

  Thanks

• lanky_doodle

  SSCrazy

  Points: 2381

  More actions

  February 12, 2018 at 7:28 am

  #1979415

  I've totally binned this idea. I've instead fabricated an additional column which is bit (true if favourite, false if not).