"You're mixing up "working knowledge of SQL" with "expert knowledge of RDBMSes. I agree I am nowhere close to an RDBMS expert. However, I can use SQL, which was the point of the original post."
Hmm you seem to be laboring under a concept that to know how to join two tables you need to be an RDBMS "expert" and "working knowledge" is not sufficient.
On the contrary, if you can't join two tables with SQL, you don't have any "working knowledge of SQL". Neither can you "use SQL" worth a damn. Every answer you make exposes the hollowness of your supposed "working knowledge"!
"However, I can use SQL"
Sure, as long as you query single tables (and do joins "at the application level") ;-)
> Hmm you seem to be laboring under a concept that to know how to join two tables you need to be an RDBMS "expert"
You're misreading. You kept bringing up the point of "expert" knowledge (e.g. in C and for-loops), or knowledge of RDBMSes, and saying you couldn't know X without also knowing Y.
As the question was about SQL, NOT RDBMSes or "expert"-level knowledge of SQL or RDBMSes, I pointed that out.
> On the contrary, if you can't join two tables with SQL, you don't have any "working knowledge of SQL".
Depends on what "can't" you're talking about. I can look it up and then do it. A lot of people don't remember the syntax. Obviously anyone with working knowledge CAN do a join; the question was whether they could tell you how to do it off the top of their head.
Even things you've used a lot, if you haven't used them recently, you'd likely slip up in an interview.
> Every answer you make exposes the hollowness of your supposed "working knowledge"!
Not really. I can make things work (hence "working knowledge") and look up what I don't know and use it right away.
I've been using in-memory databases and of course the equivalent of a JOIN is a basic function but it's not an SQL JOIN.
Hmm you seem to be laboring under a concept that to know how to join two tables you need to be an RDBMS "expert" and "working knowledge" is not sufficient.
On the contrary, if you can't join two tables with SQL, you don't have any "working knowledge of SQL". Neither can you "use SQL" worth a damn. Every answer you make exposes the hollowness of your supposed "working knowledge"!
"However, I can use SQL"
Sure, as long as you query single tables (and do joins "at the application level") ;-)