Question

select count(*) from table1 select count(*) from table2 select count(*) from table3

我从table1 table2 table3 中 找数据的条数
怎样一下子用一条sql语句 算出TABLE1 TABLE2 TABLE3 记录的总和？？

Answer 1

Some people put it ,mulberry bags

sent to your blog, and some property companies as it Tips for

posted in the elevator, it has become a lot

the art of human speech guide.

hurry, slow to speak. Case of emergency, if you think

heart can sink and not rash to make things clear that

, will leave a steady listener, not impulsive impression,

thereby increasing the confidence of others to you.

small, humorous said. In particular, some well-intentioned

reminder, talk it out with a joke, do not let the listener

feel stiff, they will not only embrace you for reminding me,

will also enhance mutual intimacy.

not sure what, cautious says.

Who did not grasp their own thing, if you do not, people will think you

false; precise wording if you can say, people will

feel you are worthy of trust.

did not happen, no nonsense. People hate

much ado about nothing, and if you never casual or

nonsense speculation no matter, will make people think you are man mature,

have very good, is a work serious, responsible people.

can not do, Freeze said. As the saying goes, Do not promise

own can not do, will make listeners feel like you are a

a > you.

injury of people, can not say. Not easily hurt by words

language to others, especially among people in the more intimate,

not say hurtful words. This will make them think you are

a kind person to help maintain and promote feelings.

sad thing, not telling anyone says.

In injury time heart the desire to have a say, but if telling anyone that it is easy to make the listener

too much pressure on you and doubt

alienation. At the same time, you will also give the impression that people not for his sake

, the pain onto others the impression of trying.

other things, be careful to say.

Between people need a safe distance, do not easily review and communication

of people, give people a sense of security exchanges.

own business, listening to how others say.

Own things to listen to the views of outsiders, one can

give the impression of modesty; two will make people think you

is sensible to people.

elders do, and listen more talk less. Older people do not like to

to young people made their own thing too much

comment if that's too young, they may feel

You are not a respect for the elderly, humble, studious person.

couple of things to discuss with the said. Between husband and wife,mac makeup,

fear most is that something happens recriminations.

children's things,mulberry alexa, enlighten and said. Spring Green

especially of children, is very rebellious, with a mild degree of state

enlighten, you can only let the children have a crush on you,

can play a convincing role.

you laugh, the whole world laughs with you; you cry, only one person you cry

Answer 2

select sum(c) from (
select count(*) c from table1
UNION select count(*) c from table2
UNION select count(*) c from table3
) t
使用UNION将三条查询的结果合并,再外套一层求和.

Answer 3

先union 再sum() ，不细写了，让你去复习下sql语句的资料，呵呵