帮助选择成员，Mysql [英] Help with selecting members, Mysql

问题描述

您好，


我想从''userTBL''中选择''live_properties''表中没有任何

属性的用户，两个表都有一个相同的列

称为''用户名''

我有2个表称为''usersTBL''和''live_properties''

存储在''usersTBL''中的用户信息及其属性存储在

''live_properties''


提前感谢


思南

解决方案

Sinan Osan写道：

你好，
我想从''userTBL''中选择''live_properties''表中没有任何
属性的用户，两个表都有一个相同的列
''username''
我有两个名为''usersTBL''和''live_properties''的表格，用户信息存储在''usersTBL''中，其属性存储在
''live_properties''
提前感谢
思南

我建议你得到一本书 - 甚至谷歌搜索如何

JOIN表。 SQL for Dummies是一个execellant初学者工具。我们可以

给你答案，但是你不会从中学到很多东西。


我也想知道世界上你究竟是怎么回事得到一份工作，却不知道一些数据库查询的基础知识。

我需要一个答案或建议不是聪明的评论，

为什么你以这样的态度加入这样的团体

对会员。

这是我自己的项目，不适合你聪明的工作。

如果你不知道如何帮助就说出来。

Hello,

I want to select the users from ''userTBL'' which does not have any
property in ''live_properties'' table, Both table has a same column
called ''username''

I have 2 tables called ''usersTBL'' and ''live_properties''
user info stored in ''usersTBL'' and their properties stored in
''live_properties''

thanks in advance

Sinan

解决方案

Sinan Osan wrote:

Hello, I want to select the users from ''userTBL'' which does not have any
property in ''live_properties'' table, Both table has a same column
called ''username'' I have 2 tables called ''usersTBL'' and ''live_properties''
user info stored in ''usersTBL'' and their properties stored in
''live_properties'' thanks in advance Sinan

I would suggest that you get a book - or even a google search on how to
JOIN tables. "SQL for Dummies" is an execellant beginners tool. We can
give you the answer, but then you don''t learn a whole lot from it.

I also wonder how in the world you actually got a job without knowing some
of the very basics of database queries.

I need a answer or suggestion not a smart comment,
why did you join in to a group like this with an attitude like that
towards members.

This is for my own project not for work you smart ass.
just say it if you don''t know how to help.

这篇关于帮助选择成员，Mysql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！