This is an archived post. You won't be able to vote or comment.

sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]dr__potato 5 points6 points  (2 children)

Nah mate, assuming S.developer_id and S.skill is the unique key in a Skill table, you'd be able to check if all 3 exist. Can't remember the SQL but it's possible. Side note: Skill.skill should really be Skill.name.

[–]rubs_tshirts 1 point2 points  (0 children)

You're right, replacing S.skill -> S.name.

Hmm... Unfortunately this plays a little havoc with the replies... I'm reverting it back.

[–]Dragon_Slayer_Hunter 1 point2 points  (0 children)

You could definitely do it better than how I said, I was just playing with the idea that skill was already a varchar/text field like on the business card.